﻿<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../Connections/test.jsp" %>
<%
  String Recordset1__MMColParam = "1";
  if (request.getParameter("friendID") != null) {
    Recordset1__MMColParam = (String) request.getParameter("friendID");
  }
%>
<%
  Driver DriverRecordset1 = (Driver) Class.forName(MM_test_DRIVER).newInstance();
  Connection ConnRecordset1 = DriverManager.getConnection(MM_test_STRING, MM_test_USERNAME, MM_test_PASSWORD);
  PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM shengwuyixue.friends WHERE friendID = " + Recordset1__MMColParam + "");
  ResultSet Recordset1 = StatementRecordset1.executeQuery();
  boolean Recordset1_isEmpty = !Recordset1.next();
  boolean Recordset1_hasData = !Recordset1_isEmpty;
  Object Recordset1_data;
  int Recordset1_numRows = 0;
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
  <title>北京交通大学计算机与信息技术学院生物医学工程系</title>
  <link href="<%=request.getContextPath()%>/include/css/css.css" rel="stylesheet" type="text/css"/>
  <style type="text/css">
    <!--
    .STYLE1 {
      font-size: 16px;
      font-weight: bold;
    }

    .STYLE3 {
      font-size: 18px;
      font-weight: bold;
    }

    .STYLE5 {
      font-size: 16px
    }

    .STYLE6 {
      font-size: 16;
      font-weight: bold;
      color: #FFFFFF;
    }

    -->
  </style>
  <script type="text/JavaScript">
    <!--
    function MM_goToURL() { //v3.0
      var i, args = MM_goToURL.arguments;
      document.MM_returnValue = false;
      for (i = 0; i < (args.length - 1); i += 2) eval(args[i] + ".location='" + args[i + 1] + "'");
    }
    //-->
  </script>
</head>
<body>
<div class="zhong">

  <jsp:include page="/include/banner.jsp"/>
  <jsp:include page="/include/menu.jsp"/>

  <div class="main">
    <div class="left">
      <div class="box_1">
        <div class="left_title STYLE1">系友录</div>
        <div class="left_news">
          <ul>
            <li><a href="friends_bachelor.jsp" class="hover">本科生系友</a></li>

            <li><a href="friends_master.jsp">研究生系友</a></li>
            <li><a href="friends_doctor.jsp">博士生系友</a></li>
          </ul>
        </div>
      </div>
    </div>
    <div class="right">
      <div class="right_title STYLE5">
        <p>系友录</p>
        <hr/>
        <p>&nbsp;</p>
        <p>&nbsp;</p>
        <p>&nbsp;</p>
        <p>&nbsp;</p>
        <table width="96%" border="0">
          <tr>
            <td>
              <div align="right">系友姓名：</div>
            </td>
            <td><%=(((Recordset1_data = Recordset1.getObject("name")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>
            </td>
          </tr>
          <tr>
            <td>
              <div align="right">照片：</div>
            </td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td height="19">
              <div align="right">性别：</div>
            </td>
            <td><%=(((Recordset1_data = Recordset1.getObject("gender")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>
            </td>
          </tr>
          <tr>
            <td>
              <div align="right">专业：</div>
            </td>
            <td><%=(((Recordset1_data = Recordset1.getObject("major")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>
            </td>
          </tr>
          <tr>
            <td>
              <div align="right">方向：</div>
            </td>
            <td><%=(((Recordset1_data = Recordset1.getObject("direction")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>
            </td>
          </tr>
          <tr>
            <td>
              <div align="right">简介：</div>
            </td>
            <td><%=(((Recordset1_data = Recordset1.getObject("introduction")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>
            </td>
          </tr>
          <tr>
            <td>
              <div align="right">毕业时间：</div>
            </td>
            <td><%=(((Recordset1_data = Recordset1.getObject("graduate_year")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>
            </td>
          </tr>
          <tr>
            <td>
              <div align="right">所获学位：</div>
            </td>
            <td><%=(((Recordset1_data = Recordset1.getObject("degree")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>
            </td>
          </tr>
        </table>
        <p>&nbsp;</p>
        <p align="center">
          <input name="Submit" type="button"
                 onclick="MM_goToURL('parent','friends_bachelor.jsp');return document.MM_returnValue" value="返回"/>
          &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
          <input name="Submit2" type="button"
                 onclick="MM_goToURL('parent','../index.jsp');return document.MM_returnValue" value="退出"/>
        </p>
        <p>&nbsp;</p>
        <p>&nbsp;</p>
        <p>&nbsp;</p>
        <p>&nbsp;</p>
      </div>
      <div class="liebiao">

      </div>
    </div>
    <!--这里是链接模块-->
    <div class="clear"></div>
    <div class="huoban">
      <div class="huoban_title STYLE7">友情链接</div>
      <div class="huoban_nr">
        <ul>
          <li class="STYLE11">北京交通大学计算机与信息技术学院</li>
          <li class="STYLE11">北京交通大学主页</li>
          <li class="STYLE11">北京交通大学知行论坛</li>
          <li class="STYLE11">北京交通大学图书馆</li>
          <li></li>
          <li></li>
        </ul>
        <div class="clear"></div>
      </div>
    </div>
    <div class="clear"></div>
  </div>


  <div class="clear"></div>
</div>
<div class="bottom">
  <p>地址：北京市海淀区上园村3号北京交通大学信息中心　邮编：100044　 </p>
  <p>北京交通大学计算机与信息技术学院生物医学工程系保留网站所有权利</p>
  <p> 未经允许不得复制、镜像</p>
  <p>京公网安备：110402430059 号</p>
  <br/>
  版权所有&copy;ouchanghai,cit.bjtu.
</div>
</div>
<script src="<%=request.getContextPath()%>/include/js/meun.js" type="text/javascript"></script>
</body>
</html>
<%
  Recordset1.close();
  StatementRecordset1.close();
  ConnRecordset1.close();
%>
